The basic of Dynamic Open SQL commands is the usage of variables or
parameters within the SELECT statement. This can be done by carefully
constructing its components such as FROM, INTO and WHERE statements. Even though
Dynamic Open SQL has been developed since Release 3.0, the major development
with enhanced features will only be available in Release 6.10. This release
includes features such as:
Creating internal tables dynamically
Simplify the programming by allowing more transparent and
integrated codes
Additional exception handling within the codes.
Even though some of the essential commands will not available until
6.10 released, the basic features of Dynamic Open SQL (Release 4.6) has been
considered as a major development on common Open SQL.